<?php

class RCMS_Object_Product_ProductFeedModel extends RCMS_Core_BaseModel {

	public function fetchExtended() {
		$select = $this->getAdapter()->select()
			->from(
				array(
					'sas' => 'specs_attributes_string'
				),
				array(
					'productId'   => 'product_id',
					'attributeId' => 'attribute_id',
					'value'       => 'value'
				)
			)
			->join(
				array(
					'sa' => 'specs_attributes'
				),
				'sas.attribute_id = sa.id',
				array(
					'name'
				)
			);
		return $this->getAdapter()->fetchAll($select);
	}

}

